中间库：172.30.0.170:1521/orcl
账号/密码：jwzjk1/jwzjk1

create or replace view jwzjk1.GXJX_KCSJLB as select * from 
jw_user.GXJX_KCSJLB;--课程数据
/
comment on column  jwzjk1.GXJX_KCSJLB.zhxs is '周学时';
comment on column  jwzjk1.GXJX_KCSJLB.XF is '学分';
comment on column  jwzjk1.GXJX_KCSJLB.SYXS is '实验学时';
comment on column  jwzjk1.GXJX_KCSJLB.KCH is '课程号';                     唯一值
comment on column  jwzjk1.GXJX_KCSJLB.KCMC is '课程名称';                                          课程名字
comment on column  jwzjk1.GXJX_KCSJLB.KCYWMC is '课程英文名称';
comment on column  jwzjk1.GXJX_KCSJLB.ZXS is '总学时';
comment on column  jwzjk1.GXJX_KCSJLB.LLXS is '理论学时';
comment on column  jwzjk1.GXJX_KCSJLB.KCJJ is '课程简介';
comment on column  jwzjk1.GXJX_KCSJLB.JC is '教材';
comment on column  jwzjk1.GXJX_KCSJLB.CKSM is '参考书目';
comment on column  jwzjk1.GXJX_KCSJLB.KCFZRH is '课程负责人号';
comment on column  jwzjk1.GXJX_KCSJLB.KCKSDWH is '课程开设单位号';
comment on column  jwzjk1.GXJX_KCSJLB.SJXS is '实践学时';
comment on column  jwzjk1.GXJX_KCSJLB.SFSYK is '是否双语课';
comment on column  jwzjk1.GXJX_KCSJLB.TKRQ is '停开日期';
comment on column  jwzjk1.GXJX_KCSJLB.KCHLBM is '课程类别码';
comment on column  jwzjk1.GXJX_KCSJLB.KSRQ3 is '开设日期';
comment on column  jwzjk1.GXJX_KCSJLB.KCJXDG is '课程教学大纲';
comment on column  jwzjk1.GXJX_KCSJLB.KCJBM is '课程级别';
comment on column  jwzjk1.GXJX_KCSJLB.KCLBM is '课程类别';
comment on column  jwzjk1.GXJX_KCSJLB.KCLBmc is '课程类别名称';
comment on column  jwzjk1.GXJX_KCSJLB.KCLXM is '课程类型';
comment on column  jwzjk1.GXJX_KCSJLB.KCLXmc is '课程类型名称';
comment on column  jwzjk1.GXJX_KCSJLB.SFTK is '是否停开';
comment on column  jwzjk1.GXJX_KCSJLB.TKRQSJ is '停开日期时间';
comment on column  jwzjk1.GXJX_KCSJLB.KSRQSJ is '开设日期时间';
comment on column  jwzjk1.GXJX_KCSJLB.ZHGXSJ is '最后更新时间';
comment on column  jwzjk1.GXJX_KCSJLB.SCBZ is '删除标志：y/n';
comment on column  jwzjk1.GXJX_KCSJLB.YXKC is '预修课程';
create or replace view jwzjk1.GXJX_PKSJL as select * from jw_user.GXJX_PKSJL;--排课数据
/
comment on column jwzjk1.GXJX_PKSJL.KCXZ is '课程性质码';
comment on column jwzjk1.GXJX_PKSJL.JXBMC is '教学班名称';
comment on column jwzjk1.GXJX_PKSJL.JXTZ is '教学特征';
comment on column jwzjk1.GXJX_PKSJL.JXZY is '教学资源';
comment on column jwzjk1.GXJX_PKSJL.JXBH is '教学班号';                  班号
comment on column jwzjk1.GXJX_PKSJL.KKSM is '开课说明';
comment on column jwzjk1.GXJX_PKSJL.KCKSDWH is '课程开设单位号';
comment on column jwzjk1.GXJX_PKSJL.KKXND is '开课学年度';                                查询的年度码 
comment on column jwzjk1.GXJX_PKSJL.KKXQM is '开课学期码';                               学期
comment on column jwzjk1.GXJX_PKSJL.SKSJ is '上课时间';
comment on column jwzjk1.GXJX_PKSJL.JXDD is '教学地点';
comment on column jwzjk1.GXJX_PKSJL.KRL is '课容量';
comment on column jwzjk1.GXJX_PKSJL.XDRS is '修读人数';
comment on column jwzjk1.GXJX_PKSJL.JSSZXQH is '教室所在校区号';
comment on column jwzjk1.GXJX_PKSJL.XKXQH is '选课校区号';
comment on column jwzjk1.GXJX_PKSJL.XKRSXD is '选课人数限定';
comment on column jwzjk1.GXJX_PKSJL.XKNJ is '选课年级';
comment on column jwzjk1.GXJX_PKSJL.PKYQ is '排课要求';
comment on column jwzjk1.GXJX_PKSJL.JSLXM is '教室类型码';
comment on column jwzjk1.GXJX_PKSJL.QSZ is '起始周';
comment on column jwzjk1.GXJX_PKSJL.ZZZ is '终止周';
comment on column jwzjk1.GXJX_PKSJL.JSGH is '教师工号';                    教师工号 有多个
comment on column jwzjk1.GXJX_PKSJL.JSXM is '教师姓名';
comment on column jwzjk1.GXJX_PKSJL.SKBJH is '上课班级号';
comment on column jwzjk1.GXJX_PKSJL.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXJX_PKSJL.SCBZ is '删除标志：y/n';
comment on column jwzjk1.GXJX_PKSJL.KCSXM is '课程属性码';
comment on column jwzjk1.GXJX_PKSJL.KSS is '课时数';

create or replace view jwzjk1.GXJX_XKSJLB as select * from jw_user.GXJX_XKSJLB; --选课数据
/
comment on column jwzjk1.GXJX_XKSJLB.YXYQ is '院系要求';
comment on column jwzjk1.GXJX_XKSJLB.XKZY is '选课志愿';
comment on column jwzjk1.GXJX_XKSJLB.XKSJ is '选课时间';
comment on column jwzjk1.GXJX_XKSJLB.KCH is '课程号';
comment on column jwzjk1.GXJX_XKSJLB.KXH is '课序号';
comment on column jwzjk1.GXJX_XKSJLB.NJYQ is '年级要求';
comment on column jwzjk1.GXJX_XKSJLB.ZYYQ is '专业要求';
comment on column jwzjk1.GXJX_XKSJLB.XQYQ is '校区要求';
comment on column jwzjk1.GXJX_XKSJLB.SFCX is '是否重修';
comment on column jwzjk1.GXJX_XKSJLB.XKLCM is '选课轮次码';
comment on column jwzjk1.GXJX_XKSJLB.XKRQ is '选课日期';
comment on column jwzjk1.GXJX_XKSJLB.JXBH is '教学班号';                                         教学班号
comment on column jwzjk1.GXJX_XKSJLB.KSRQ is '考试日期';
comment on column jwzjk1.GXJX_XKSJLB.KSSJ is '考试时间';
comment on column jwzjk1.GXJX_XKSJLB.KSJSH is '考试教室号';
comment on column jwzjk1.GXJX_XKSJLB.KSZWH is '考试座位号';
comment on column jwzjk1.GXJX_XKSJLB.XH is '学号';                                               根据学号查询
comment on column jwzjk1.GXJX_XKSJLB.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXJX_XKSJLB.SCBZ is '删除标志：y/n';

create or replace view jwzjk1.GXJX_ZYXXSJLB as select * from jw_user.GXJX_ZYXXSJLB;--专业信息
/
comment on column jwzjk1.GXJX_ZYXXSJLB.JLNY is '建立年月';
comment on column jwzjk1.GXJX_ZYXXSJLB.XKMLM is '学科门类码';
comment on column jwzjk1.GXJX_ZYXXSJLB.BZKZYM is '本专科专业码';
comment on column jwzjk1.GXJX_ZYXXSJLB.YJSZYM is '研究生专业码';
comment on column jwzjk1.GXJX_ZYXXSJLB.QSXQ is '起始学期';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZYH is '专业号';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZYMC is '专业名称';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZYJC is '专业简称';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZYYWMC is '专业英文名称';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZYFXH is '专业方向号';
comment on column jwzjk1.GXJX_ZYXXSJLB.DWH is '单位号';
comment on column jwzjk1.GXJX_ZYXXSJLB.XZ is '学制';
comment on column jwzjk1.GXJX_ZYXXSJLB.CC is '层次';
comment on column jwzjk1.GXJX_ZYXXSJLB.XW is '学位';
comment on column jwzjk1.GXJX_ZYXXSJLB.XKLB is '学科类别';
comment on column jwzjk1.GXJX_ZYXXSJLB.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXJX_ZYXXSJLB.SCBZ is '删除标志：y/n';

create or replace view jwzjk1.GXXS_BJSJZL as select * from jw_user.GXXS_BJSJZL;--班级信息
/
comment on column jwzjk1.GXXS_BJSJZL.SSNJ is '所属年级';
comment on column jwzjk1.GXXS_BJSJZL.BZRGH is '班主任工号';
comment on column jwzjk1.GXXS_BJSJZL.JBNY is '建班年月';
comment on column jwzjk1.GXXS_BJSJZL.BZXH is '班长学号';
comment on column jwzjk1.GXXS_BJSJZL.FDYH is '辅导员号';
comment on column jwzjk1.GXXS_BJSJZL.SFDDB is '是否订单班';
comment on column jwzjk1.GXXS_BJSJZL.BH is '班号';
comment on column jwzjk1.GXXS_BJSJZL.BJJC is '班级简称';
comment on column jwzjk1.GXXS_BJSJZL.BJMC is '班级名称';
comment on column jwzjk1.GXXS_BJSJZL.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXXS_BJSJZL.SCBZ is '删除标志：y/n';
comment on column jwzjk1.GXXS_BJSJZL.SSXYDM is '所属学院代码';
comment on column jwzjk1.GXXS_BJSJZL.SSZYDM is '所属专业代码';

create or replace view jwzjk1.GXXS_XJJBSJZLB as select * from jw_user.GXXS_XJJBSJZLB;--学生学籍信息
/
comment on column jwzjk1.GXXS_XJJBSJZLB.PYFS is '培养方式';
comment on column jwzjk1.GXXS_XJJBSJZLB.PYCC is '培养层次';
comment on column jwzjk1.GXXS_XJJBSJZLB.XKML is '学科门类';
comment on column jwzjk1.GXXS_XJJBSJZLB.YJFX is '研究方向';
comment on column jwzjk1.GXXS_XJJBSJZLB.DSH is '导师号';
comment on column jwzjk1.GXXS_XJJBSJZLB.HDXLFSM is '获得学历方式码';
comment on column jwzjk1.GXXS_XJJBSJZLB.SFXFZ is '是否学分制';
comment on column jwzjk1.GXXS_XJJBSJZLB.LDFSM is '连读方式码';
comment on column jwzjk1.GXXS_XJJBSJZLB.XSDQZT is '学生当前状态';
comment on column jwzjk1.GXXS_XJJBSJZLB.RXNY is '入学年月';
comment on column jwzjk1.GXXS_XJJBSJZLB.XSLB is '学生类别';
comment on column jwzjk1.GXXS_XJJBSJZLB.SZBH is '所在班号';                      学生班号 查询到 班级课程
comment on column jwzjk1.GXXS_XJJBSJZLB.SZNJ is '所在年级';
comment on column jwzjk1.GXXS_XJJBSJZLB.YXSH is '院系所号';
comment on column jwzjk1.GXXS_XJJBSJZLB.ZYM is '专业码';
comment on column jwzjk1.GXXS_XJJBSJZLB.SFZC is '是否注册';
comment on column jwzjk1.GXXS_XJJBSJZLB.SFZX is '是否在校';
comment on column jwzjk1.GXXS_XJJBSJZLB.XQmc is '校区名称';                           校区名字
comment on column jwzjk1.GXXS_XJJBSJZLB.XXXSM is '学习形式码';
comment on column jwzjk1.GXXS_XJJBSJZLB.XXXS is '学习形式';
comment on column jwzjk1.GXXS_XJJBSJZLB.XXNX is '学习年限';
comment on column jwzjk1.GXXS_XJJBSJZLB.LQLBM is '录取类别码';
comment on column jwzjk1.GXXS_XJJBSJZLB.RXFS is '入学方式码';
comment on column jwzjk1.GXXS_XJJBSJZLB.JDFS is '就读方式码';
comment on column jwzjk1.GXXS_XJJBSJZLB.XSLY is '学生来源码';
comment on column jwzjk1.GXXS_XJJBSJZLB.XH is '学号';                                           学号
comment on column jwzjk1.GXXS_XJJBSJZLB.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXXS_XJJBSJZLB.SCBZ is '删除标志：y/n';
comment on column jwzjk1.GXXS_XJJBSJZLB.KSH is '考生号';
comment on column jwzjk1.GXXS_XJJBSJZLB.BYRQ is '毕业日期';
comment on column jwzjk1.GXXS_XJJBSJZLB.XZ is '学制';

create or replace view jwzjk1.GXXS_XSJBSJZL as select * from jw_user.GXXS_XSJBSJZL;--学生基本信息
/
comment on column jwzjk1.GXXS_XSJBSJZL.YWXM is '英文姓名';
comment on column jwzjk1.GXXS_XSJBSJZL.XBM is '性别码';
comment on column jwzjk1.GXXS_XSJBSJZL.MZM is '民族码';
comment on column jwzjk1.GXXS_XSJBSJZL.HYZKM is '婚姻状况码';
comment on column jwzjk1.GXXS_XSJBSJZL.XYZJM is '信仰宗教码';
comment on column jwzjk1.GXXS_XSJBSJZL.SFDSZN is '是否独生子女';
comment on column jwzjk1.GXXS_XSJBSJZL.XH is '学号';                                             需要
comment on column jwzjk1.GXXS_XSJBSJZL.XM is '姓名';                                             需要
comment on column jwzjk1.GXXS_XSJBSJZL.XMPY is '姓名拼音';                
comment on column jwzjk1.GXXS_XSJBSJZL.CYM is '曾用名';
comment on column jwzjk1.GXXS_XSJBSJZL.CSRQ is '出生日期';
comment on column jwzjk1.GXXS_XSJBSJZL.CSDM is '出生地码';
comment on column jwzjk1.GXXS_XSJBSJZL.JG is '籍贯';
comment on column jwzjk1.GXXS_XSJBSJZL.GJDQM is '国籍/地区码';
comment on column jwzjk1.GXXS_XSJBSJZL.SFZJLXM is '身份证件类型码';
comment on column jwzjk1.GXXS_XSJBSJZL.SFZJH is '身份证件号';                               需要
comment on column jwzjk1.GXXS_XSJBSJZL.GATQWM is '港澳台侨外码';
comment on column jwzjk1.GXXS_XSJBSJZL.ZZMMM is '政治面貌码';
comment on column jwzjk1.GXXS_XSJBSJZL.JKZKM is '健康状况码';
comment on column jwzjk1.GXXS_XSJBSJZL.XXM is '血型码';
comment on column jwzjk1.GXXS_XSJBSJZL.ZP is '照片';
comment on column jwzjk1.GXXS_XSJBSJZL.SFZJYXQ is '身份证件有效期';
comment on column jwzjk1.GXXS_XSJBSJZL.KSH is '考生号';
comment on column jwzjk1.GXXS_XSJBSJZL.DWH is '单位号';
comment on column jwzjk1.GXXS_XSJBSJZL.SZBH is '所在班号';                                     需要
comment on column jwzjk1.GXXS_XSJBSJZL.SFZX is '是否在校';
comment on column jwzjk1.GXXS_XSJBSJZL.SFYBY is '是否已毕业';
comment on column jwzjk1.GXXS_XSJBSJZL.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXXS_XSJBSJZL.SCBZ is '删除标志：y/n';

--成绩信息
create or replace view jwzjk1.GXXS_CJZLB as select * from jw_user.GXXS_CJZLB;
/
comment on column GXXS_CJZLB.KCH is '课程号';                                         课程信息关联查询
comment on column GXXS_CJZLB.XQM is '学期码';                                    学期
comment on column GXXS_CJZLB.KSFS is '考试方式码';
comment on column GXXS_CJZLB.FSLKSCJ is '分数类考试成绩';
comment on column GXXS_CJZLB.RKJSGH is '任课教师工号';
comment on column GXXS_CJZLB.XF is '学分';
comment on column GXXS_CJZLB.CJLRRH is '成绩录入人号';
comment on column GXXS_CJZLB.CJLRRQ is '成绩录入日期';
comment on column GXXS_CJZLB.CJLRSJ is '成绩录入时间';
comment on column GXXS_CJZLB.JD is '绩点';                                           绩点 
comment on column GXXS_CJZLB.KCCJ is '课程成绩';                                成绩
comment on column GXXS_CJZLB.KCDJCJM is '课程等级成绩码';
comment on column GXXS_CJZLB.XN is '学年（度）';                                学年
comment on column GXXS_CJZLB.KSRQ is '考试日期';
comment on column GXXS_CJZLB.PSCJ is '平时成绩';
comment on column GXXS_CJZLB.KSXZM is '考试性质码';
comment on column GXXS_CJZLB.KSXSM is '考试形式码';
comment on column GXXS_CJZLB.DJLKSCJ is '等级类考试成绩';
comment on column GXXS_CJZLB.BKCJ is '补考成绩';
comment on column GXXS_CJZLB.CXCJ is '重修成绩';
comment on column GXXS_CJZLB.SCBZ is '删除标志：y/n';
comment on column GXXS_CJZLB.XH is '学号';                                           学号
comment on column GXXS_CJZLB.JXBH is '教学班号';                                班级关联查询
comment on column GXXS_CJZLB.ZSCJ is '折算成绩';
comment on column GXXS_CJZLB.JMCJ is '卷面成绩';
comment on column GXXS_CJZLB.ZHGXSJ is '最后更新时间';
create or replace view jwzjk1.GXJX_JSJBSJZLB as select * from jw_user.GXJX_JSJBSJZLB;  ----教室信息
/
comment on column jwzjk1.GXJX_JSJBSJZLB.JSH is '教室号';
comment on column jwzjk1.GXJX_JSJBSJZLB.JSYT is '教室用途';
comment on column jwzjk1.GXJX_JSJBSJZLB.KSZWS is '考试座位数';
comment on column jwzjk1.GXJX_JSJBSJZLB.JSGLBM is '教室管理部门';
comment on column jwzjk1.GXJX_JSJBSJZLB.XQH is '校区号';
comment on column jwzjk1.GXJX_JSJBSJZLB.JXLH is '教学楼号';
comment on column jwzjk1.GXJX_JSJBSJZLB.JXLmc is '教学楼名称';
comment on column jwzjk1.GXJX_JSJBSJZLB.SZLC is '所在楼层';
comment on column jwzjk1.GXJX_JSJBSJZLB.ZWS is '座位数';
comment on column jwzjk1.GXJX_JSJBSJZLB.YXZWS is '有效座位数';
comment on column jwzjk1.GXJX_JSJBSJZLB.JSLXM is '教室类型码';
comment on column jwzjk1.GXJX_JSJBSJZLB.JSLX is '教室类型';
comment on column jwzjk1.GXJX_JSJBSJZLB.JSMS is '教室描述';
comment on column jwzjk1.GXJX_JSJBSJZLB.ZHGXSJ is '最后更新时间';
comment on column jwzjk1.GXJX_JSJBSJZLB.SCBZ is '删除标志：y/n';
comment on column jwzjk1.GXJX_JSJBSJZLB.jsmc is '教室名称';
comment on column jwzjk1.GXJX_JSJBSJZLB.KYF is '是否可用';
create or replace view jwzjk1.GXJX_JSSYSJZLB as select * from jw_user.GXJX_JSSYSJZLB; --教室使用情况
/
comment on column  jwzjk1.GXJX_JSSYSJZLB.JSZYQKM is '教室占用情况码';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SYRQ is '使用日期';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SYJC is '使用节次';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SYRH is '使用人号';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SYRSF is '使用人身份';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SKCD is '上课长度';
comment on column  jwzjk1.GXJX_JSSYSJZLB.XQJ is '星期几';
comment on column  jwzjk1.GXJX_JSSYSJZLB.JSH is '教室号';
comment on column  jwzjk1.GXJX_JSSYSJZLB.ZHGXSJ is '最后更新时间';
comment on column  jwzjk1.GXJX_JSSYSJZLB.SCBZ is '删除标志：y/n';

create or replace view jwzjk1.XB as select * from jw_user.XB; --性别
create or replace view jwzjk1.MZ as select * from jw_user.MZ; --民族
create or replace view jwzjk1.hyzk as select * from jw_user.hyzk;--婚姻状况
create or replace view jwzjk1.zjlx as select * from jw_user.zjlx;--证件类型
create or replace view jwzjk1.GAT as select * from jw_user.GAT;  --港澳台
create or replace view jwzjk1.ZZMMM as select * from jw_user.ZZMMM;--政治面貌
create or replace view jwzjk1.jg as select * from jw_user.jg;  --机构
create or replace view jwzjk1.xq as select * from jw_user.xq;  --校区

